Errors similar to the following might be displayed in the SAS^® Data Integration Studio log when running any of the jobs delivered with SAS Performance Management Solutions release 5.1.   These jobs are located in the Products->SAS Solutions Services->5.1 Jobs folder in SAS Data Integration Studio. 

The error displayed below was generated when running the <solnsvc_4100_export_dimension> job, but the error is not limited to running this specific job.

dimCode=PRODUCT includeUserXMemberData=N includeSecurityData=N exportLib=stagedds
exportDimension() - Error exporting dimension: PRODUCT, System property "Solutions Svc 5.1" is not defined.
ERROR: Execution terminated by an ABORT statement at line 211 column 247.
includeUserXMemberData=N includeSecurityData=N src= dimCode=PRODUCT exportLib=stagedds
msg=exportDimension() - Error exporting dimension: PRODUCT, System property "Solutions Svc 5.1" 
is not defined. _ERROR_=1 _N_=1
- login() - login failed.
com.sas.solutions.j2ee.naming.EnvironmentFactoryInitializationException: The System property 
"env.factory.location" isn't set.
at com.sas.solutions.j2ee.naming.EnvironmentFactory.<init>(EnvironmentFactory.java:65)
at com.sas.solutions.j2ee.naming.EnvironmentFactory.getInstance(EnvironmentFactory.java:111)
at com.sas.solutions.etl.metadata.client.MDLoad.login(MDLoad.java:501)
at com.sas.solutions.etl.metadata.client.MDLoad.setCredential(MDLoad.java:71)
- setCredential() - Error trying to login to midtier , 
com.sas.solutions.j2ee.naming.EnvironmentFact
oryInitializationException: The 
System property "env.factory.location" isn't set., The System property "env.factory.location" isn't set.
java.lang.Exception: com.sas.solutions.j2ee.naming.EnvironmentFactoryInitializationException: The 
System property "env.factory.location" isn't set.
at com.sas.solutions.etl.metadata.client.MDLoad.login(MDLoad.java:518)
at com.sas.solutions.etl.metadata.client.MDLoad.setCredential(MDLoad.java:71)
Caused by: com.sas.solutions.j2ee.naming.EnvironmentFactoryInitializationException: The System 
property "env.factory.location" 
isn't set.
at com.sas.solutions.j2ee.naming.EnvironmentFactory.<init>(EnvironmentFactory.java:65)
at com.sas.solutions.j2ee.naming.EnvironmentFactory.getInstance(EnvironmentFactory.java:111)
at com.sas.solutions.etl.metadata.client.MDLoad.login(MDLoad.java:501)
... 1 more
- exportDimension() - Error exporting dimension: PRODUCT, System property "Solutions Svc 5.1" is 
not defined.

This error most likely occurs because the <-Denv.factory.location> was not specified in the <sasv9_usermods.cfg> file when migrating from SAS Solutions release 9.1.3 to SAS Solutions  9.2.

To correct this error:

1. Make a backup copy of the <sasv9_usermods.cfg> file, which is typically located in the

   <<installdrive>:\SAS\Config\Lev1\SASApp>

   directory on the data tier machine.
2. Edit the file and add the following line; note that you will need to specify the name of the SAS Solutions mid-tier server and might also need to modify the mid-tier port number.

   -JREOPTIONS=(-Denv.factory.location=http://solutions-mid-tier-server:7201/SASConfig/EnvironmentFactory.xml)
   

3. Save the file.
4. You will need to re-start the SAS Object Spawner for this change to take effect.

Operating System and Release Information